ISRO CSE 2015
Q61.
If one uses straight two-way merge sort algorithm to sort the following elements in ascending order:20, 47, 15, 8, 9, 4, 40, 30, 12, 17then the order of these elements after second pass of the algorithm is:Q62.
Consider the following relational query on the above database: SELECT S.name FROM Suppliers S Where S.sid NOT IN (SELECT C.sid FROM Catalog C WHERE C.pid NOT IN (SELECT P.pid FROM Parts P WHERE P.color <>'blue'))Q63.
If the sequence of operations - push (1), push (2), pop, push (1), push (2), pop, pop, pop, push (2), pop are performed on a stack, the sequence of popped out valuesQ64.
Consider the following program. main() { fork(); fork(); fork(); }How many new processes will be created?Q65.
Consider the following log sequence of two transactions on a bank account, with initial balance 12000, that transfer 2000 to a mortgage payment and then apply a 5% interest.1.T1 start 2.T1 B old =1200 new =100003.T1 M old =0 new =20004.T1 commit5.T2 start6.T2 B old =10000 new =105007.T2 commitSuppose the database system crashes just before log record 7 is written. When the system is restarted, which one statement is true of the recovery procedure?Q66.
Consider the following schema:Emp (Empcode, Name, Sex, Salary, Deptt)A simple SQL query is executed as follows: SELECT Deptt FROM Emp GROUP by Dept Having avg (Salary) > {select avg (Salary) from Emp}The output will be